• ICAB3018B - Develop macros and templates for clients using standard products

Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners

ICAB3018B Mapping and Delivery Guide
Develop macros and templates for clients using standard products

Version 1.0
Issue Date: April 2024


Qualification -
Unit of Competency ICAB3018B - Develop macros and templates for clients using standard products
Description This unit defines the competency required to develop macros and templates for clients using industry recognised software applications.The following unit is linked and forms an appropriate cluster:ICAU3028B Customise packaged software applications for clientsNo licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication.
Employability Skills This unit contains employability skills.
Learning Outcomes and Application
Duration and Setting X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting.
Prerequisites/co-requisites ICAU3126B Use advanced features of computer applications
Competency Field
Development and validation strategy and guide for assessors and learners Student Learning Resources Handouts
Activities
Slides
PPT
Assessment 1 Assessment 2 Assessment 3 Assessment 4
Elements of Competency Performance Criteria              
Element: Determine macro or template requirement
  • Determine client requirements, ensuring they are in line with organisational guidelines
  • Develop macro or template specification
  • Confirm that macro or template specification meets the clients needs and operational guidelines
  • Determine documentation requirements
       
Element: Develop macro or template for client
  • Develop macro or template to specification using industry-recognised software applications
  • Demonstrate macro or template to client and obtain feedback
  • Amend macro or template, as required by client
  • Update macro or template specification
       
Element: Provide client support for macro or template
  • Document support and instruction requirements
  • Provide documentation to client help desk for future support
       


Evidence Required

List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria, required skills and knowledge, range statement and the Assessment Guidelines for the Training Package.

Overview of assessment

Critical aspects for assessment and evidence required to demonstrate competency in this unit

Evidence of the following is essential:

Competency must be demonstrated in the development of a variety of macros and templates using at least two industry-recognised application packages. Competency must be demonstrated in the development of a specification for macros and templates.

Context of and specific resources for assessment

The general environment for these types of operations is predominantly an office environment, in which documents play a major role in communication and business activity. Thus, macros and templates are designed to accelerate the process of document production by employing rapid, automated actions on documents that often would have been created from templates. Thus, a person would demonstrate their competency by using, adapting, creating, saving and troubleshooting macros and templates.

The breadth, depth and complexity of knowledge and skills in this competency would cover selecting, adapting and transferring skills and knowledge to new environments and providing technical advice and some leadership in resolution of specified problems. This would be applied across a range of roles in a variety of contexts with some complexity in the extent and choice of options available.

Assessment must ensure:

Performance of a defined range of skilled operations, usually within a range of broader related activities involving known routines, methods and procedures, where some discretion and judgement is required in the section of equipment, services or contingency measures and within known time constraints would be characteristic.

Applications may involve some responsibility for others. Participation in teams including group or team coordination may be involved.

Method of assessment

The purpose of this unit is to define the standard of performance to be achieved in the workplace. In undertaking training and assessment activities related to this unit, consideration should be given to the implementation of appropriate diversity and accessibility practices in order to accommodate people who may have special needs. Additional guidance on these and related matters is provided in ICA05 Section 1.

Competency in this unit should be assessed using summative assessment to ensure consistency of performance in a range of contexts. This unit can be assessed either in the workplace or in a simulated environment. However, simulated activities must closely reflect the workplace to enable full demonstration of competency.

Assessment will usually include observation of real or simulated work processes and procedures and/or performance in a project context as well as questioning on underpinning knowledge and skills. The questioning of team members, supervisors, subordinates, peers and clients where appropriate may provide valuable input to the assessment process. The interdependence of units for assessment purposes may vary with the particular project or scenario.

Guidance information for assessment

Holistic assessment with other units relevant to the industry sector, workplace and job role is recommended, for example:

ICAU3028B Customise packaged software applications for clients

An individual demonstrating this competency would be able to:

Demonstrate some relevant theoretical knowledge

Apply a range of well-developed skills

Apply known solutions to a variety of predictable problems

Perform processes that require a range of well-developed skills where some discretion and judgement is required

Interpret available information, using discretion and judgement

Take responsibility for own outputs in work and learning

Take limited responsibility for the output of others

Maintain knowledge of industry products and services


Submission Requirements

List each assessment task's title, type (eg project, observation/demonstration, essay, assignment, checklist) and due date here

Assessment task 1: [title]      Due date:

(add new lines for each of the assessment tasks)


Assessment Tasks

Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.

Required skills

Troubleshooting the operation of macros: for example, to trace which action of the macro may be malfunctioning, converting documents to templates and modifying templates

Ability to use various modes of employing macros, such as creating a particular keyboard key combination for each macro or by assigning it to a custom button on a toolbar

Ability to interpret software manual instructions generally, and in particular to follow instructions for creating and using macros and templates

Required knowledge

General knowledge of functions and features of the operating system

General knowledge of software and hardware supported by the organisation

General understanding of features and functions of particular categories of commercial computing packages, in particular, procedures for creating macros and using default templates (supplied by the software application package) and creating new ones

The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.

Client may include but is not limited to:

internal departments

external organisations

clubs

individual people

internal employees

Organisationalguidelines may include but is not limited to:

personal use of email and internet access

content of emails

downloading information and accessing particular websites

opening mail with attachments

virus risk

Documentation may follow:

ISO/IEC/AS standards

audit trails

naming standards

version control

project management templates

report writing protocols

Software applications

May include but are not limited to commercial software applications; organisation-specific software; word processing, spreadsheet, database, graphic, communication packages and presentation functionalities

May include presentation applications contained in: Microsoft Office, Lotus Suite, Claris Works, Star Office or other similar applications

Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.

Observation Checklist

Tasks to be observed according to workplace/college/TAFE policy and procedures, relevant legislation and Codes of Practice Yes No Comments/feedback
Determine client requirements, ensuring they are in line with organisational guidelines 
Develop macro or template specification 
Confirm that macro or template specification meets the clients needs and operational guidelines 
Determine documentation requirements 
Develop macro or template to specification using industry-recognised software applications 
Demonstrate macro or template to client and obtain feedback 
Amend macro or template, as required by client 
Update macro or template specification 
Document support and instruction requirements 
Provide documentation to client help desk for future support 

Forms

Assessment Cover Sheet

ICAB3018B - Develop macros and templates for clients using standard products
Assessment task 1: [title]

Student name:

Student ID:

I declare that the assessment tasks submitted for this unit are my own work.

Student signature:

Result: Competent Not yet competent

Feedback to student

 

 

 

 

 

 

 

 

Assessor name:

Signature:

Date:


Assessment Record Sheet

ICAB3018B - Develop macros and templates for clients using standard products

Student name:

Student ID:

Assessment task 1: [title] Result: Competent Not yet competent

(add lines for each task)

Feedback to student:

 

 

 

 

 

 

 

 

Overall assessment result: Competent Not yet competent

Assessor name:

Signature:

Date:

Student signature:

Date: